level trigger

next, create a statement-level trigger for this table

然后，创建此表的语句级触发器

互联网摘选

to declare a trigger as a statement-level trigger, you can either use a for each statement clause or omit the for each clause.

要将触发器声明为语句级触发器，可以使用FOREACHSTATEMENT子句或忽略FOREACH子句。

互联网摘选

a row-level trigger executes once for each row that is changed.

行级别触发器为更改的每一行执行一次。

互联网摘选

methods for preventing needless interrupts under level trigger request manner

防止电平触发方式下发生不必要中断的方法

互联网摘选

how do i view the definition of a server-level trigger?

如何查看服务器级别触发器的定义？

互联网摘选

a statement-level trigger executes after the entire triggering statement is completed.

语句级别触发器在整个触发语句完成后执行。

互联网摘选

this is a foreign key reference back to the server-level trigger where this module is defined.

这是返回给定义该模块的服务器级别触发器的FOREIGNKEY引用。

互联网摘选

the next example, which is more complex, deals with a statement-level trigger.

下一个示例更复杂，涉及语句级触发器。

互联网摘选

second was the statement level trigger that you have just shown. by the time i came back, you are already there with the solution.

第二个是你已经提供的语句级触发器。我回复时你已经提供了这个方法。

互联网摘选

the first example creates a row-level trigger.

第一个示例创建行级触发器。

互联网摘选

for clarity, it is recommended that you enter the for each statement clause if declaring a statement-level trigger.

为清楚起见，建议在声明语句级触发器时输入FOREACHSTATEMENT子句。

互联网摘选

a row-level trigger fires once for each row affected, while a statement-level trigger fires once for the entire statement.

行级别触发器为受影响的每一行触发一次，而语句级别触发器则为整个语句触发一次。

互联网摘选

the meaning of referencing old and referencing new differs, depending on whether the trigger is a row-level or a statement-level trigger.

REFERENCINGOLD和REFERENCINGNEW的含义不同，具体取决于触发器是行级还是语句级触发器。

互联网摘选